Keyboard shortcuts

For Windows/Linux:

Working with Spreadsheet

Open 'File' panel

Alt+F

Open the File panel to save, download, print the current spreadsheet, view its info, create a new spreadsheet or open an existing one, access the help menu of the Spreadsheet Editor or its advanced settings.

Open 'Find and Replace' dialog box

Ctrl+F

Open the Find and Replace dialog box to start searching for a cell containing the required characters.

Open 'Find and Replace' dialog box with replacement field

Ctrl+H

Open the Find and Replace dialog box with the replacement field to replace one or more occurrences of the found characters.

Open 'Comments' panel

Ctrl+⇧ Shift+H

Open the Comments panel to add your own comment or reply to other users' comments.

Open comment field

Alt+H

Open a data entry field where you can add the text of your comment.

Open 'Chat' panel

Alt+Q

Open the Chat panel and send a message.

Save spreadsheet

Ctrl+S

Save all the changes to the spreadsheet currently edited with the Spreadsheet Editor. The active file will be saved with its current file name, location, and file format.

Print spreadsheet

Ctrl+P

Print your spreadsheet with one of the available printers or save it to a file.

Download as...

Ctrl+⇧ Shift+S

Open the Download as... panel to save the currently edited spreadsheet to the computer hard disk drive in one of the supported formats: XLSX, PDF, ODS, CSV, XLTX, PDF/A, OTS.

Full screen

F11

Switch to the full screen view to fit the Spreadsheet Editor on the screen.

Help menu

F1

Open the Help menu of the Spreadsheet Editor .

Open existing file (Desktop Editors)

Ctrl+O

Open the standard dialog box on the Open local file tab in the Desktop Editors that allows you to select an existing file.

Close file (Desktop Editors)

Tab/Shift+Tab

Close the current spreadsheet window in the Desktop Editors.

Element contextual menu

⇧ Shift+F10

Open the contextual menu of the selected element.

Reset the ‘Zoom’ parameter

Ctrl+0

Reset the ‘Zoom’ parameter of the current spreadsheet to a default 100%.

Navigation

Move one cell up, down, left, or right

← → ↑ ↓

Outline a cell above/below the currently selected one or to the left/to the right of it.

Jump to the edge of the current data region

Ctrl+← → ↑ ↓

Outline a cell at the edge of the current data region in a worksheet.

Jump to the beginning of the row

Home

Outline a cell in the column A of the current row.

Jump to the beginning of the spreadsheet

Ctrl+Home

Outline the cell A1.

Jump to the end of the row

End,

Ctrl+→

Outline the last cell of the current row.

Jump to the end of the spreadsheet

Ctrl+End

Outline the lower right used cell in the worksheet situated in the bottommost row with data of the rightmost column with data. If the cursor is in the formula bar, it will be placed to the end of the text.

Move to the previous sheet

Alt+Page Up

Move to the previous sheet in your spreadsheet.

Move to the next sheet

Alt+Page Down

Move to the next sheet in your spreadsheet.

Move up one row

↑,

⇧ Shift+↵ Enter

Outline the cell above the current one in the same column.

Move down one row

↓,

↵ Enter

Outline the cell below the current one in the same column.

Move left one column

←,

⇧ Shift+↹ Tab

Outline the previous cell of the current row.

Move right one column

→,

↹ Tab

Outline the next cell of the current row.

Move down one screen

Page Down

Move one screen down in the worksheet.

Move up one screen

Page Up

Move one screen up in the worksheet.

Zoom In

Ctrl++

Zoom in the currently edited spreadsheet.

Zoom Out

Ctrl+-

Zoom out the currently edited spreadsheet.

Navigate between controls in modal dialogues

↹ Tab/⇧ Shift+↹ Tab

Navigate between controls to give focus to the next or previous control in modal dialogues.

Data Selection

Select all

Ctrl+A,

Ctrl+⇧ Shift+␣ Spacebar

Select the entire worksheet.

Select column

Ctrl+␣ Spacebar

Select an entire column in a worksheet.

Select row

⇧ Shift+␣ Spacebar

Select an entire row in a worksheet.

Select fragment

⇧ Shift+→ ←

Select a fragment cell by cell.

Select from cursor to beginning of row

⇧ Shift+Home

Select a fragment from the cursor to the beginning of the current row.

Select from cursor to end of row

⇧ Shift+End

Select a fragment from the cursor to the end of the current row.

Extend the selection to beginning of worksheet

Ctrl+⇧ Shift+Home

Select a fragment from the current selected cells to the beginning of the worksheet.

Extend the selection to the last used cell

Ctrl+⇧ Shift+End

Select a fragment from the current selected cells to the last used cell in the worksheet (in the bottommost row with data of the rightmost column with data). If the cursor is in the formula bar, this will select all text in the formula bar from the cursor position to the end without affecting the height of the formula bar.

Select one cell to the left

⇧ Shift+↹ Tab

Select one cell to the left in a table.

Select one cell to the right

↹ Tab

Select one cell to the right in a table.

Extend the selection to the nearest nonblank cell to the right

⇧ Shift+Alt+End,

Ctrl+⇧ Shift+→

Extend the selection to the nearest nonblank cell in the same row to the right of the active cell. If the next cell is blank, the selection will be extended to the next nonblank cell.

Extend the selection to the nearest nonblank cell to the left

⇧ Shift+Alt+Home,

Ctrl+⇧ Shift+←

Extend the selection to the nearest nonblank cell in the same row to the left of the active cell. If the next cell is blank, the selection will be extended to the next nonblank cell.

Extend the selection to the nearest nonblank cell up/down the column

Ctrl+⇧ Shift+↑ ↓

Extend the selection to the nearest nonblank cell in the same column up/down from the active cell. If the next cell is blank, the selection will be extended to the next nonblank cell.

Extend the selection down one screen

⇧ Shift+Page Down

Extend the selection to include all the cells one screen down from the active cell.

Extend the selection up one screen

⇧ Shift+Page Up

Extend the selection to include all the cells one screen up from the active cell.

Undo and Redo

Undo

Ctrl+Z

Reverse the latest performed action.

Redo

Ctrl+Y

Repeat the latest undone action.

 

Cut, Copy, and Paste

Cut

Ctrl+X,

⇧ Shift+Delete

Cut the the selected data and send them to the computer clipboard memory. The cut data can be later inserted to another place in the same worksheet, into another spreadsheet, or into some other program.

Copy

Ctrl+C,

Ctrl+Insert

Send the selected data to the computer clipboard memory. The copied data can be later inserted to another place in the same worksheet, into another spreadsheet, or into some other program.

Paste

Ctrl+V,

⇧ Shift+Insert

Insert the previously copied/cut data from the computer clipboard memory to the current cursor position. The data can be previously copied from the same worksheet, from another spreadsheet, or from some other program.

Data Formatting

Bold

Ctrl+B

Make the font of the selected text fragment darker and heavier than normal or remove the bold formatting.

Italic

Ctrl+I

Make the font of the selected text fragment italicized and slightly slanted or remove italic formatting.

Underline

Ctrl+U

Make the selected text fragment underlined with a line going under the letters or remove underlining.

Strikeout

Ctrl+5

Make the selected text fragment struck out with a line going through the letters or remove strikeout formatting.

Add Hyperlink

Ctrl+K

Insert a hyperlink to an external website or another worksheet.

Edit active cell

F2

Edit the active cell and position the insertion point at the end of the cell contents. If editing in a cell is turned off, the insertion point will be moved into the Formula Bar.

Data Filtering

Enable/Remove Filter

Ctrl+⇧ Shift+L

Enable a filter for a selected cell range or remove the filter.

Format as table template

Ctrl+L

Apply a table template to a selected cell range.

 

Data Entry

Complete cell entry and move down

↵ Enter

Complete a cell entry in the selected cell or the formula bar, and move to the cell below.

Complete cell entry and move up

⇧ Shift+↵ Enter

Complete a cell entry in the selected cell, and move to the cell above.

Start new line

Alt+↵ Enter

Start a new line in the same cell.

Cancel

Esc

Cancel an entry in the selected cell or the formula bar.

Delete to the left

← Backspace

Delete one character to the left in the formula bar or in the selected cell when the cell editing mode is activated. Also removes the content of the active cell.

Delete to the right

Delete

Delete one character to the right in the formula bar or in the selected cell when the cell editing mode is activated. Also removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments.

Clear cell content

Delete,

← Backspace

Remove the content (data and formulas) from selected cells without affecting the cell format or comments.

Complete a cell entry and move to the right

↹ Tab

Complete a cell entry in the selected cell or the formula bar and move to the cell on the right.

Complete a cell entry and move to the left

⇧ Shift+↹ Tab

Complete a cell entry in the selected cell or the formula bar and move to the cell on the left .

Insert cells

Ctrl+⇧ Shift+=

Open the dialog box for inserting new cells within current spreadsheet with an added parameter of a shift to the right, a shift down, inserting an entire row or an entire column.

Delete cells

Ctrl+⇧ Shift+-

Open the dialog box for deleting cells within current spreadsheet with an added parameter of a shift to the left, a shift up, deleting an entire row or an entire column.

Insert the current date

Ctrl+;

Insert the today date within an active cell.

Insert the current time

Ctrl+⇧ Shift+;

Insert the current time within an active cell.

Insert the current date and time

Ctrl+; then ␣ Spacebar then Ctrl+⇧ Shift+;

Insert the current date and time within an active cell.

Functions

Insert function

⇧ Shift+F3

Open the dialog box for inserting a new function by choosing from the provided list.

SUM function

Alt+=

Insert the SUM function into the selected cell.

Open drop-down list

Alt+↓

Open a selected drop-down list.

Open contextual menu

≣ Menu

Open a contextual menu for the selected cell or cell range.

Recalculate functions

F9

Recalculate the entire workbook.

Recalculate functions

⇧ Shift+F9

Recalculate the current worksheet.

Data Formats

Data Formats

Data Formats

Open the 'Number Format' dialog box

Ctrl+1

Open the Number Format dialog box.

Apply the General format

Ctrl+⇧ Shift+~

Apply the General number format.

Apply the Currency format

Ctrl+⇧ Shift+$

Apply the Currency format with two decimal places (negative numbers in parentheses).

Apply the Percentage format

Ctrl+⇧ Shift+%

Apply the Percentage format with no decimal places.

Apply the Exponential format

Ctrl+⇧ Shift+^

Apply the Exponential number format with two decimal places.

Apply the Date format

Ctrl+⇧ Shift+#

Apply the Date format with the day, month, and year.

Apply the Time format

Ctrl+⇧ Shift+@

Apply the Time format with the hour and minute, and AM or PM.

Apply the Number format

Ctrl+⇧ Shift+!

Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

Modifying Objects

Constrain movement

⇧ Shift + drag

Constrain the movement of the selected object horizontally or vertically.

Set 15-degree rotation

⇧ Shift + drag (when rotating)

Constrain the rotation angle to 15-degree increments.

Maintain proportions

⇧ Shift + drag (when resizing)

Maintain the proportions of the selected object when resizing.

Draw straight line or arrow

⇧ Shift + drag (when drawing lines/arrows)

Draw a straight vertical/horizontal/45-degree line or arrow.

Movement by one-pixel increments

Ctrl+← ↑ ↓

Hold down the Ctrl key and use the keybord arrows to move the selected object by one pixel at a time.

For Mac OS:

Working with Spreadsheet

Open 'File' panel

⌥ Option+F

Open the File panel to save, download, print the current spreadsheet, view its info, create a new spreadsheet or open an existing one, access the help menu of the Spreadsheet Editor or its advanced settings.

Open 'Find and Replace' dialog box

^ Ctrl+F,

⌘ Cmd+F

Open the Find and Replace dialog box to start searching for a cell containing the required characters.

Open 'Find and Replace' dialog box with replacement field

^ Ctrl+H

Open the Find and Replace dialog box with the replacement field to replace one or more occurrences of the found characters.

Open 'Comments' panel

^ Ctrl+⇧ Shift+H,

⌘ Cmd+⇧ Shift+H

Open the Comments panel to add your own comment or reply to other users' comments.

Open comment field

⌥ Option+H

Open a data entry field where you can add the text of your comment.

Open 'Chat' panel

⌥ Option+Q

Open the Chat panel and send a message.

Save spreadsheet

^ Ctrl+S,

⌘ Cmd+S

Save all the changes to the spreadsheet currently edited with the Spreadsheet Editor. The active file will be saved with its current file name, location, and file format.

Print spreadsheet

^ Ctrl+P,

⌘ Cmd+P

Print your spreadsheet with one of the available printers or save it to a file.

Download as...

^ Ctrl+⇧ Shift+S,

⌘ Cmd+⇧ Shift+S

Open the Download as... panel to save the currently edited spreadsheet to the computer hard disk drive in one of the supported formats: XLSX, PDF, ODS, CSV, XLTX, PDF/A, OTS.

Help menu

F1

Open the Help menu of the Spreadsheet Editor .

Close file (Desktop Editors)

↹ Tab/⇧ Shift+↹ Tab

Close the current spreadsheet window in the Desktop Editors.

Element contextual menu

⇧ Shift+F10

Open the contextual menu of the selected element.

Reset the ‘Zoom’ parameter

^ Ctrl+0 or ⌘ Cmd+0

Reset the ‘Zoom’ parameter of the current spreadsheet to a default 100%.

Navigation

Move one cell up, down, left, or right

↑ ↓

Outline a cell above/below the currently selected one or to the left/to the right of it.

Jump to the edge of the current data region

⌘ Cmd+← ↑ ↓

Outline a cell at the edge of the current data region in a worksheet.

Jump to the beginning of the row

Home

Outline a cell in the column A of the current row.

Jump to the beginning of the spreadsheet

^ Ctrl+Home

Outline the cell A1.

Jump to the end of the row

End,

⌘ Cmd+→

Outline the last cell of the current row.

Jump to the end of the spreadsheet

^ Ctrl+End

Outline the lower right used cell in the worksheet situated in the bottommost row with data of the rightmost column with data. If the cursor is in the formula bar, it will be placed to the end of the text.

Move to the previous sheet

⌥ Option+Page Up

Move to the previous sheet in your spreadsheet.

Move to the next sheet

⌥ Option+Page Down

Move to the next sheet in your spreadsheet.

Move up one row

⇧ Shift+↵ Return

Outline the cell above the current one in the same column.

Move down one row

↵ Return

Outline the cell below the current one in the same column.

Move left one column

←,

⇧ Shift+↹ Tab

Outline the previous cell of the current row.

Move right one column

→,

↹ Tab

Outline the next cell of the current row.

Move down one screen

Page Down

Move one screen down in the worksheet.

Move up one screen

Page Up

Move one screen up in the worksheet.

Zoom In

^ Ctrl+=,

⌘ Cmd+=

Zoom in the currently edited spreadsheet.

Zoom Out

^ Ctrl+-,

⌘ Cmd+-

Zoom out the currently edited spreadsheet.

Navigate between controls in modal dialogues

↹ Tab/⇧ Shift+↹ Tab

Navigate between controls to give focus to the next or previous control in modal dialogues.

Data Selection

Select all

⌘ Cmd+A

Select the entire worksheet.

Select column

^ Ctrl+␣ Spacebar

Select an entire column in a worksheet.

Select row

⇧ Shift+␣ Spacebar

Select an entire row in a worksheet.

Select fragment

⇧ Shift+→ ←

Select a fragment cell by cell.

Select from cursor to beginning of row

⇧ Shift+Home

Select a fragment from the cursor to the beginning of the current row.

Select from cursor to end of row

⇧ Shift+End

Select a fragment from the cursor to the end of the current row.

Extend the selection to beginning of worksheet

^ Ctrl+⇧ Shift+Home

Select a fragment from the current selected cells to the beginning of the worksheet.

Extend the selection to the last used cell

^ Ctrl+⇧ Shift+End

Select a fragment from the current selected cells to the last used cell in the worksheet (in the bottommost row with data of the rightmost column with data). If the cursor is in the formula bar, this will select all text in the formula bar from the cursor position to the end without affecting the height of the formula bar.

Select one cell to the left

⇧ Shift+↹ Tab

Select one cell to the left in a table.

Select one cell to the right

↹ Tab

Select one cell to the right in a table.

Extend the selection to the nearest nonblank cell to the right

⇧ Shift+⌥ Option+End

Extend the selection to the nearest nonblank cell in the same row to the right of the active cell. If the next cell is blank, the selection will be extended to the next nonblank cell.

Extend the selection to the nearest nonblank cell to the left

⇧ Shift+⌥ Option+Home

Extend the selection to the nearest nonblank cell in the same row to the left of the active cell. If the next cell is blank, the selection will be extended to the next nonblank cell.

Extend the selection down one screen

⇧ Shift+Page Down

Extend the selection to include all the cells one screen down from the active cell.

Extend the selection up one screen

⇧ Shift+Page Up

Extend the selection to include all the cells one screen up from the active cell.

Undo and Redo

Undo

⌘ Cmd+Z

Reverse the latest performed action.

Redo

⌘ Cmd+Y

Repeat the latest undone action.

Data Filtering

Enable/Remove Filter

^ Ctrl+⇧ Shift+L,

⌘ Cmd+⇧ Shift+L

Enable a filter for a selected cell range or remove the filter.

Format as table template

^ Ctrl+L,

⌘ Cmd+L

Apply a table template to a selected cell range.

Cut, Copy, and Paste

Cut

⌘ Cmd+X

Cut the the selected data and send them to the computer clipboard memory. The cut data can be later inserted to another place in the same worksheet, into another spreadsheet, or into some other program.

Copy

⌘ Cmd+C

Send the selected data to the computer clipboard memory. The copied data can be later inserted to another place in the same worksheet, into another spreadsheet, or into some other program.

Paste

⌘ Cmd+V

Insert the previously copied/cut data from the computer clipboard memory to the current cursor position. The data can be previously copied from the same worksheet, from another spreadsheet, or from some other program.

Data Formatting

Bold

^ Ctrl+B,

⌘ Cmd+B

Make the font of the selected text fragment darker and heavier than normal or remove the bold formatting.

Italic

^ Ctrl+I,

⌘ Cmd+I

Make the font of the selected text fragment italicized and slightly slanted or remove italic formatting.

Underline

^ Ctrl+U,

⌘ Cmd+U

Make the selected text fragment underlined with a line going under the letters or remove underlining.

Strikeout

^ Ctrl+5,

⌘ Cmd+5

Make the selected text fragment struck out with a line going through the letters or remove strikeout formatting.

Add Hyperlink

⌘ Cmd+K

Insert a hyperlink to an external website or another worksheet.

Edit active cell

F2

Edit the active cell and position the insertion point at the end of the cell contents. If editing in a cell is turned off, the insertion point will be moved into the Formula Bar.

Data Entry

Complete cell entry and move down

↵ Return

Complete a cell entry in the selected cell or the formula bar, and move to the cell below.

Complete cell entry and move up

⇧ Shift+↵ Return

Complete a cell entry in the selected cell, and move to the cell above.

Cancel

Esc

Cancel an entry in the selected cell or the formula bar.

Delete to the left

← Backspace

Delete one character to the left in the formula bar or in the selected cell when the cell editing mode is activated. Also removes the content of the active cell.

Delete to the right

Delete,

Fn+← Backspace

Delete one character to the right in the formula bar or in the selected cell when the cell editing mode is activated. Also removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments.

Clear cell content

Delete,

← Backspace

Remove the content (data and formulas) from selected cells without affecting the cell format or comments.

Complete a cell entry and move to the right

↹ Tab

Complete a cell entry in the selected cell or the formula bar and move to the cell on the right.

Complete a cell entry and move to the left

⇧ Shift+↹ Tab

Complete a cell entry in the selected cell or the formula bar and move to the cell on the left .

Insert cells

Ctrl+⇧ Shift+=

Open the dialog box for inserting new cells within current spreadsheet with an added parameter of a shift to the right, a shift down, inserting an entire row or an entire column.

Delete cells

Ctrl+⇧ Shift+-

Open the dialog box for deleting cells within current spreadsheet with an added parameter of a shift to the left, a shift up, deleting an entire row or an entire column.

Insert the current date

Ctrl+;

Insert the today date within an active cell.

Insert the current time

Ctrl+⇧ Shift+;

Insert the current time within an active cell.

Insert the current date and time

Ctrl+; then ␣ Spacebar then Ctrl+⇧ Shift+;

Insert the current date and time within an active cell.

Functions

Insert function

⇧ Shift+F3

Open the dialog box for inserting a new function by choosing from the provided list.

SUM function

⌥ Option+=

Insert the SUM function into the selected cell.

Recalculate functions

F9

Recalculate the entire workbook.

Recalculate functions

⇧ Shift+F9

Recalculate the current worksheet.

Data Formats

Open the 'Number Format' dialog box

^ Ctrl+1

Open the Number Format dialog box.

Apply the General format

^ Ctrl+⇧ Shift+~

Apply the General number format.

Apply the Currency format

^ Ctrl+⇧ Shift+$

Apply the Currency format with two decimal places (negative numbers in parentheses).

Apply the Percentage format

^ Ctrl+⇧ Shift+%

Apply the Percentage format with no decimal places.

Apply the Exponential format

^ Ctrl+⇧ Shift+^

Apply the Exponential number format with two decimal places.

Apply the Date format

^ Ctrl+⇧ Shift+#

Apply the Date format with the day, month, and year.

Apply the Time format

^ Ctrl+⇧ Shift+@

Apply the Time format with the hour and minute, and AM or PM.

Apply the Number format

^ Ctrl+⇧ Shift+!

Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

Modifying Objects

Constrain movement

⇧ Shift + drag

Constrain the movement of the selected object horizontally or vertically.

Set 15-degree rotation

⇧ Shift + drag (when rotating)

Constrain the rotation angle to 15-degree increments.

Maintain proportions

⇧ Shift + drag (when resizing)

Maintain the proportions of the selected object when resizing.

Draw straight line or arrow

⇧ Shift + drag (when drawing lines/arrows)

Draw a straight vertical/horizontal/45-degree line or arrow.